Purchasing Receipt History (POP30300)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt History (POP30300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP30300

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt History
Physical Name: POP30300
Technical Name: POP_ReceiptHist

Group Display Name: Purchasing History
Group Technical Name: Purchasing History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
2	POPTYPE	POP Type	Integer	DDL_POP_Type	0
3	VNDDOCNM	Vendor Document Number	String	STR20_Document_Number	20
4	receiptdate	Receipt Date	Date	DT	8
5	GLPOSTDT	GL Posting Date	Date	DT	8
6	ACTLSHIP	Actual Ship Date	Date	DT	8
7	BCHSOURC	Batch Source	String	STR15	15
	Records whether the transaction was entered in a batch or not. Click to show/hide the Batch Sources PM_Trxent Batch XXPM_Trxent No batch (real-time)
8	BACHNUMB	Batch Number	String	STR15_LBAU	15
9	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchasing Receipt History'].VENDORID AS 'Purchasing Receipt History-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchasing Receipt History'].VENDORID = ['PM Vendor Master File'].VENDORID
10	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
11	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
12	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
13	TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	Trade Discount Percent (Precise)	23
14	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
15	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
16	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
17	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
18	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['Purchasing Receipt History'].PYMTRMID AS 'Purchasing Receipt History-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['Purchasing Receipt History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
19	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
20	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
21	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
22	DISCDATE	Discount Date	Date	DT	8
23	DUEDATE	Due Date	Date	DT	8
24	REFRENCE	Reference	String	STR30	30
25	VOIDSTTS	Void Status	Integer	INT	0
26	RCPTNOTE_1	Receipt Note ID Array[1]	Currency	DLR14	14
27	RCPTNOTE	Receipt Note ID Array	DLR14	Currency	14
28	RCPTNOTE_2	Receipt Note ID Array[2]	Currency	DLR14	14
29	RCPTNOTE_3	Receipt Note ID Array[3]	Currency	DLR14	14
30	RCPTNOTE_4	Receipt Note ID Array[4]	Currency	DLR14	14
31	RCPTNOTE_5	Receipt Note ID Array[5]	Currency	DLR14	14
32	RCPTNOTE_6	Receipt Note ID Array[6]	Currency	DLR14	14
33	RCPTNOTE_7	Receipt Note ID Array[7]	Currency	DLR14	14
34	RCPTNOTE_8	Receipt Note ID Array[8]	Currency	DLR14	14
35	POPHDR1	POP HDR Errors 1	Long Integer	ML_POP_HDR_Errors_1	0
36	POPHDR2	POP HDR Errors 2	Long Integer	ML_POP_HDR_Errors_2	0
37	POPLNERR	POP LINE Errors	Long Integer	ML_POP_LINE_Errors	0
38	POSTEDDT	Posted Date	Date	DATE	6
39	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Receipt History'].PTDUSRID AS 'Purchasing Receipt History-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Receipt History'].PTDUSRID = ['Users Master'].USERID
40	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Receipt History'].USER2ENT AS 'Purchasing Receipt History-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Receipt History'].USER2ENT = ['Users Master'].USERID
41	CREATDDT	Created Date	Date	DT	8
42	MODIFDT	Modified Date	Date	DT	8
43	TRXSORCE	TRX Source	String	STR13	13
44	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['Purchasing Receipt History'].VCHRNMBR AS 'Purchasing Receipt History-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['Purchasing Receipt History'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['Purchasing Receipt History'].DOCTYPE = ['PM Key Master File'].DOCTYPE
45	Tax_Date	Tax Date	Date	DT	8
46	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt History'].CURNCYID AS 'Purchasing Receipt History-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt History'].CURNCYID = ['Currency Setup'].CURNCYID
47	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt History'].CURRNIDX AS 'Purchasing Receipt History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt History'].CURRNIDX = ['Currency Setup'].CURRNIDX
48	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Purchasing Receipt History'].RATETPID AS 'Purchasing Receipt History-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Purchasing Receipt History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
49	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Purchasing Receipt History'].EXGTBLID AS 'Purchasing Receipt History-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Purchasing Receipt History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
50	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
51	EXCHDATE	Exchange Date	Date	DT_Date	6
52	TIME1	Time	Time	TM6	6
53	RATECALC	Rate Calc Method	Integer	INT	0
	Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank. Click to show/hide Rate Calc Methods 0 Multiply 1 Divide
54	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
55	MCTRXSTT	MC Transaction State	Integer	INT1	1
	MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank. Click to show/hide MC Transaction States 0 Euro currency is not created or no denomination currencies are enabled. 1 Originating is not a denomination; Functional is not a denomination 2 Originating is not a denomination; Functional is the Euro currency. 3 Originating is not a denomination; Functional is a denomination. 4 Originating is a denomination; Functional is not a denomination. 5 Originating is a denomination; Functional is a denomination. 6 Originating is a denomination; Functional is the Euro currency. 7 Originating is the Euro currency; Functional is a denomination. 8 Originating is the Euro currency; Functional is not a denomination.
56	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
57	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
58	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
59	ORMISCAMT	Originating Misc Amount	Currency	DLR19_RBSO_UTR$	19
60	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
61	OR1099AM	Originating 1099 Amount	Currency	DLR17_RBS0_UTR$	17
62	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
63	ORDAVAMT	Originating Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
64	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
65	WITHHAMT	Withholding Amount	Currency	DLR19_RBSO_UTR$	19
66	ECTRX	EC Transaction	Boolean	CB_EC_Transaction	0
	The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
67	TXRGNNUM	Tax Registration Number	String	STR25	25
68	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt History'].TAXSCHID AS 'Purchasing Receipt History-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
69	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
70	Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	DDL_Purchase_Tax_Options	0
71	Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	DDL_Purchase_Tax_Options	0
72	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt History'].FRTSCHID AS 'Purchasing Receipt History-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt History'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt History'].MSCSCHID AS 'Purchasing Receipt History-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt History'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
74	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
75	ORFRTTAX	Originating Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
76	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
77	ORMSCTAX	Originating Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
78	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
79	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
80	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
81	BackoutFreightTaxAmt	Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
82	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
83	BackoutMiscTaxAmt	Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
84	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
85	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
86	APLYWITH	Apply Withholding	Boolean	Boolean	0
87	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
88	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchasing Receipt History'].SHIPMTHD AS 'Purchasing Receipt History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchasing Receipt History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
89	Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
90	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
91	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['Purchasing Receipt History'].VADCDTRO AS 'Purchasing Receipt History-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM POP30300 AS ['Purchasing Receipt History'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['Purchasing Receipt History'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['Purchasing Receipt History'].VENDORID = ['PM Address MSTR'].VENDORID
92	REVALJRNENTRY	Revaluation Journal Entry	Long Integer	LI8_U0	8
93	REVALTRXSOURCE	Revaluation TRX Source	String	STR13	13
94	TEN99TYPE	1099 Type	Integer	1099_Type	0
95	TEN99BOXNUMBER	1099 Box Number	Integer	DDL_1099_Box	0
96	REPLACEGOODS	Replace Returned Goods	Boolean	CB_ReplaceReturnedGoods	0
97	INVOICEEXPECTED	Invoice Expected Returns	Boolean	CB_InvoiceExpectedReturns	0
98	PrepaymentAmount	Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
99	OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
100	POP_HDR_Errors_4	POP HDR Errors 4	Long Integer	ML_POP_HDR_Errors_4	0
101	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
102	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
103	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
104	ORDATKN	Originating Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
105	InvoiceReceiptDate	Invoice Receipt Date	Date	DT	8
	Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
106	Workflow_Status	Workflow Status	Integer	Workflow Status	0

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt History (POP30300)

Leave a Reply Cancel reply